﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// Summary description for QLKetBan
/// </summary>
public class QLKetBan
{
    ConnectionProcess data = new ConnectionProcess();
	public QLKetBan()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public DataTable Load_KetBan()
    {
        return data.Get_data("Load_KetBan");
    }
    public string Load_NguoiGui(int matk)
    {
        SqlParameter p1 = new SqlParameter("@matk", matk);
        object kq = data.LayDuLieu("Load_NguoiGui", p1);
        return kq.ToString();
    }
    public string Load_NguoiNhan(int matk)
    {
        SqlParameter p1 = new SqlParameter("@matk", matk);
        object kq = data.LayDuLieu("Load_NguoiGui", p1);
        return kq.ToString();
    }
    public DataTable Del_KB(int makb)
    {
        SqlParameter p1 = new SqlParameter("@makb", makb);
        return data.Get_data("Del_KB", p1);
    }
}
